| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Users from switching worksheet
The following code will hide the worksheet tabs from the user. I do not know if this is sufficient to solve your proble
ActiveWindow.DisplayWorkbookTabs = False |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent Users from switching worksheet
ActiveWindow.DisplayWorkbookTabs = False
John M. Thanks. It does just what I want. Hides the tabs. Why do you think it may not be sufficient. -Elie |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent Users from switching worksheet
Hello Elie,
Any average user know that you can switch between sheets by ctrl+pageup and ctrl+pagedown. Have you red my reply to your post? Regards, "Elie" wrote in message om... ActiveWindow.DisplayWorkbookTabs = False John M. Thanks. It does just what I want. Hides the tabs. Why do you think it may not be sufficient. -Elie |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent Users from switching worksheet
Jon Jon,
Thanks. I did see your reply. I am advanced in some parts of excel but still rather novice in many things. This is my first major excel project so please bare with me. I think that your first solution will work for me (well, similar anyway because I didn't describe my requirements that accurately). Thanks, Elie. "JON JON" wrote in message ... Hello Elie, Any average user know that you can switch between sheets by ctrl+pageup and ctrl+pagedown. Have you red my reply to your post? Regards, "Elie" wrote in message om... ActiveWindow.DisplayWorkbookTabs = False John M. Thanks. It does just what I want. Hides the tabs. Why do you think it may not be sufficient. -Elie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent wandering users | Excel Discussion (Misc queries) | |||
| How do I prevent users to delete a worksheet, but allow to edit? | Excel Discussion (Misc queries) | |||
| prevent users from overwriting other users data | Excel Worksheet Functions | |||
| MACRO OR VBA CODE TO PREVENT USERS FROM PRINTING THE CONTENTS OF A WORKSHEET? | Excel Programming | |||
| Prevent users from using AutoFilter | Excel Programming | |||
![John M[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
