Dabo
05-14-2009, 07:39 AM
Hello all,
I am currently trying to prevent the user from seing some "ugly" worksheets.
I have hidden the tabs and menus but the user can still go to these sheets by pressing Alt+TAB.
I have also tried to completely hide the worksheets but it entails bugs in the macros using these worksheets. One heavy solution to that would be a macro to hide and dehide the worksheets during the calculation but it is not as clean as I'd like.
I guess that the simpler solution would be to prevent the user to use Alt+Tab,
Is it sufficient to prevent him from seing the forbidden worksheets ?
How should I do it ?
Thanks !
I am currently trying to prevent the user from seing some "ugly" worksheets.
I have hidden the tabs and menus but the user can still go to these sheets by pressing Alt+TAB.
I have also tried to completely hide the worksheets but it entails bugs in the macros using these worksheets. One heavy solution to that would be a macro to hide and dehide the worksheets during the calculation but it is not as clean as I'd like.
I guess that the simpler solution would be to prevent the user to use Alt+Tab,
Is it sufficient to prevent him from seing the forbidden worksheets ?
How should I do it ?
Thanks !