![]() |
Bulletproofing a worksheet
Is it possible to completely prevent a user from entering formulas or altering formats in unlocked cells on a worksheet? If so, what methods could be employed?
|
Bulletproofing a worksheet
Hi Fred,
Just lock the cells... |
Bulletproofing a worksheet
SuperJas
I need to have these particular cells (6 cells) unlocked as these cells serve to gather input for the calculations on the worksheet. I would like to use worksheet input rather than forms to facilitate editing of just 1-2 cells at a time and to facilitate what-if analysis, goal seek, etc. I would like to protect the formatting (fill color, number format, etc.) in these cells, and I do not want users to enter any formulas, just constant values within a certain range which I can restrict through data validation or other means. I can create custom menus and toolbars to restrict those actions that are normally available, however I am unsure of how to restrict the entry of the myriad of keyboard shortcut keys which can accomplish most anything in and of themselves. I have worked a little bit with Onkey method of Application object, but ran into problems capturing the + key on numeric keypad (I can capture + key on regular keyboard) on my own notebook computer. I am trying to ascertain if my goal of making a "bulletproof" worksheet is even feasible Thanks in advance for all assistance! |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com