I have created an excel file and protected with password.
i also want to restrict user from inserting VBA code by using Alt+F11 key.
Please help as soon as possible....
I have created an excel file and protected with password.
i also want to restrict user from inserting VBA code by using Alt+F11 key.
Please help as soon as possible....
Hi
Follow these stepas and add a password to your VBA module. That way no one should be able to add codce to your workbook:
> Open excel
> open your workbook
> hit alt-f11 (to get to the vbe)
> hit ctrl-r (to see the project explorer)
> with your project selected in the project explorer
> Tools VBAProject Properties
> Protection tab.
Hope this helps.
Tony
Thank you very much.
Its awesome dude..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks