Protecting Workbook - deleting hidden worksheets
I'm setting up a workbook and have some 2 major issues. I have 2 worksheets in the workbook that are hidden, and when a macro is run, it asks for a password, and then unhides the sheets. Only a few people will have access to this password. And the file is only located in one folder, and it's the only workbook, there are no copies.
#1 issue - I need to set up code that, if someone tries to do a "save as" to another folder, it needs to do a copy-paste values on any links that are in the workbook, between the worksheets, and delete the 2 hidden sheets from the workbook.
#2 issue - When someone opens the workbook, it needs to verify where the workbook is located. If it's not in the proper folder, it needs to run a macro that will copy-paste values on any links, and delete the hidden worksheets.
Can anyone help me with either one? I know what I want it to do, and I can kind of see the coding that needs to be done, but I do not have enough experience with coding to actually figure it out.
I would appreciate any help that I can get!
|
