My current project involves trying to prevent the user from showing sheet tabs, and of revealing columns and rows.
I can hide the menus easily enough. I am looking to code within the program to trap the events, and to cancel them or to reset back to my original state.
I can code it as:
or simply - since the time it takes to check, it may as well perform the actionVB Code:
If ActiveWindow.DisplayHeadings = true then ActiveWindow.DisplayHeadings = false If ActiveWindow.DisplayWorkbookTabs = true then ActiveWindow.DisplayWorkbookTabs = false
My question is as to the most efficient place to put it.VB Code:
ActiveWindow.DisplayHeadings = false ActiveWindow.DisplayWorkbookTabs = false
Any suggestions? Or if I can trap the events and only have the code run if needed.




Reply With Quote