Greetings to all
When I right click the tab of a worksheet, I get the option to "View Code".
I'd like to remove this option but have been unsuccessful so far. (both the
worksheet and workbook are already protected).
any clues?
Thanks, anny
Greetings to all
When I right click the tab of a worksheet, I get the option to "View Code".
I'd like to remove this option but have been unsuccessful so far. (both the
worksheet and workbook are already protected).
any clues?
Thanks, anny
Hi
In VBA editor, right-click on your VBA-project, and select Properties.
Activate Protection tab, check 'Lock project for viewing', and set a
password.
Close VBA editor and then workbook. When the workbook is opened next time,
after selecting 'View Code' the user is asked for password.
Ari Laanemets
"anny" <adorr@idirect.ca> wrote in message
news:uDw1dHEJGHA.984@tk2msftngp13.phx.gbl...
> Greetings to all
>
> When I right click the tab of a worksheet, I get the option to "View
Code".
> I'd like to remove this option but have been unsuccessful so far. (both
the
> worksheet and workbook are already protected).
>
> any clues?
> Thanks, anny
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks