Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Tabs
Hello All,
Is there a way to lock worksheet tabs so a user can access certain sheets but not others. I do not think I can hide the sheets as I have code that looks in the sheets Thanks in Advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Tabs
JC,
VBA can access hidden sheets, just don't select first. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "JC" wrote in message ... Hello All, Is there a way to lock worksheet tabs so a user can access certain sheets but not others. I do not think I can hide the sheets as I have code that looks in the sheets Thanks in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheet tabs is checked but I can't see my tabs | Excel Discussion (Misc queries) | |||
Sheet Tabs | Excel Discussion (Misc queries) | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
How do I change the Excel sheet tab bar to display more sheet tabs | Excel Discussion (Misc queries) | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions |