Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a application in which I have 6 sheets with certain number of objects in each sheet. I want to have functionality like if I select anything in a sheet (say sheet 6) that should not reflect in any other sheet(sheet 1- sheet 5). Also If I select anything in other sheets, that should not reflect in sheet 6 alone. In short, can I separeate sheet 6 from other sheets ?
Many thanks in advance.
Regards,
Sharma
Hi Guys,
I think I figured it out. It was simple enough. I just wrote a Macro something like this:
sub Selection
ActiveDocument.ClearAll False
end sub
Then I applied this Macro to Sheet 6 for both "OnActivateSheet" and also "OnLeaveSheet" and is workin perfectly now.
Thanks for your answers/suggestions.
Cheers,
Sharma
hi,
Check using the condition in General Tab of Sheet properties. Other option is to use a Macro.
Thanks and Regards,
Raghav
HI Sharma,
In settings go to Sheet Properties,There you go to security,
There you can find a checkbox readonly..Just click on that it will keep the sheet as read only.
Hope it will help solve your problem..
Regards
Sunil
Hi Raghav,
I dont want to Hide the entire sheet at all. So the Condition in the General tab of sheet properties will not be helpful(I think). May be I need to try using Macros.
Thanks for giving it a shot.
Cheers,
Sharma
Hi Sunil,
I should be able to make Selections in Sheet 6. But if you check "Read Only", you won't be able to make any selections too.
Cheers,
Sharma
Hi Sharma
Then u should prefer for writing Macro ...
Regards
sunil
Hi Guys,
I think I figured it out. It was simple enough. I just wrote a Macro something like this:
sub
SelectionActiveDocument.ClearAll False
end
Then I applied this Macro to Sheet 6 for both "OnActivateSheet" and also "OnLeaveSheet" and is workin perfectly now.
Thanks for your answers/suggestions.
Cheers,
Sharma
Hi Guys,
I think I figured it out. It was simple enough. I just wrote a Macro something like this:
sub Selection
ActiveDocument.ClearAll False
end sub
Then I applied this Macro to Sheet 6 for both "OnActivateSheet" and also "OnLeaveSheet" and is workin perfectly now.
Thanks for your answers/suggestions.
Cheers,
Sharma