FloggingDolphin
New Member
- Joined
- Jul 3, 2005
- Messages
- 25
Hi there,
I’ve been asked for some excel help from my colleague, but unfortunately she hasn’t provided me with her worksheet yet.
Basically there is two departments (say Department A and B) who need to work on the worksheet. My colleague wants the worksheet to work in such a way that Department A has only read-only access to Department B’s data, and vice versa, but both Departments can alter their own data in the worksheet.
I was thinking that one could sort of write a macro to give relevant data access to both departments by giving each one a different password and each password would activate different access settings.
The problem is that this will only work if they run the worksheet with macro’s enabled. So how can I make a worksheet that forces them to enable macros?
The best thing I can come up with is :
Create a macro with the source code having a password.
When you exit the workbook / or save it, the macro coverts the data into scrambled characters and displays a message called “YOU MUST ENABLE MACROS TO USE THIS WORKSHEET” when the workbook is saved or exit. That was the only way to convert the worksheet back into its normal status is to enable macros.
Sorry for lack of worksheet.
I've also posted this question on:
http://www.ozgrid.com/forum/showthread.php?p=218402#post218402
Mark
I’ve been asked for some excel help from my colleague, but unfortunately she hasn’t provided me with her worksheet yet.
Basically there is two departments (say Department A and B) who need to work on the worksheet. My colleague wants the worksheet to work in such a way that Department A has only read-only access to Department B’s data, and vice versa, but both Departments can alter their own data in the worksheet.
I was thinking that one could sort of write a macro to give relevant data access to both departments by giving each one a different password and each password would activate different access settings.
The problem is that this will only work if they run the worksheet with macro’s enabled. So how can I make a worksheet that forces them to enable macros?
The best thing I can come up with is :
Create a macro with the source code having a password.
When you exit the workbook / or save it, the macro coverts the data into scrambled characters and displays a message called “YOU MUST ENABLE MACROS TO USE THIS WORKSHEET” when the workbook is saved or exit. That was the only way to convert the worksheet back into its normal status is to enable macros.
Sorry for lack of worksheet.
I've also posted this question on:
http://www.ozgrid.com/forum/showthread.php?p=218402#post218402
Mark