Security...
Hi!
I was wondering how I could prevent the user from changing certain fields after a macro is run on a spreadsheet. For example after the macro is run: The user can't: insert/delete rows or columns change certain cells/rows/columns values Thank you, LC |
Security...
Try this: ActiveSheet.Protect (userinterfaceonly) You have to lock certain cells ahead of time, which you can do manually. Then, when activesheet.protect is run, users can't modify things. The userinterfaceonly option allows subroutines to continue w/ modifications. Cells.Locked = True might be usefull too. I believe that it will allow you to do the locking of certain cells from a subroutine. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Security...
And one reply from you post of a couple days ago:
http://groups.google.com/groups?thre...764D%40msn.com LC wrote: Hi! I was wondering how I could prevent the user from changing certain fields after a macro is run on a spreadsheet. For example after the macro is run: The user can't: insert/delete rows or columns change certain cells/rows/columns values Thank you, LC -- Dave Peterson |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com