![]() It also protects the sheet setting, but sets the User Interface to True so code can still run on the sheet if needed.Īnother method to customize the Excel environment and limit some user options. It disables the ability to select cells on the sheet, plus limits the scroll area to just one cell so the user cannot scroll vertically or horizontally. ![]() If you do a lot of applications that require a backdrop "Dashboard" sheet, this snippet of code helps to place some more limits on user options. The following will colour cell B2 Red whenever the cell changes. I will start out by showing how a change to a single cell can trigger an action. ![]() In Excel a Worksheet Change Event is a trigger for a macro when a cell or group of cells change. Prevent cell selection and sheet scrolling Worksheet Change Event Automatically Run Excel Macros When a Cell Changes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |