Macros
I have excel 2000 and I wish to create a macro but have limited
knowledge. What I am trying to achieve is, I want a shared document that is read only to users but by clicking a macro users get a password prompt which will then allow them write access to certain columns or cells which can then be saved. Is this possible and if so how? Any help would be greatly appreciated. |
Macros
Hi, in my opinion, you should first password protect your file and then
select the cells which you want the users to modify and uncheck the locked property. Goto Tools-Protect Worksheet in that you uncheck select unlocked cells. I hope this helps. "bbdog" wrote: I have excel 2000 and I wish to create a macro but have limited knowledge. What I am trying to achieve is, I want a shared document that is read only to users but by clicking a macro users get a password prompt which will then allow them write access to certain columns or cells which can then be saved. Is this possible and if so how? Any help would be greatly appreciated. |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com