Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
in a protected Excel spreadsheet how do you prohibit a user from adding gridlines?
It's protected except for several cells used for input
2 Answers
- Gary ELv 61 decade agoFavorite Answer
It doesn't look like you can. But you can insert the following
ActiveWindow.DisplayGridlines = False
ActiveWindow.GridlineColorIndex = 2
in the worksheet Activate, Change, and SelectionChange events to make it more difficult to do and impossible to make stick very long.
- myLv 44 years ago
Granted Excel passwords could be surely cracked. despite the fact that, with a worksheet password, VBE password secure practices, coding out the worksheet menu bar, and WorkBook_Open, WorkBook_Close, and WorkSheet_SelectionChange journey handlers you may nevertheless make the workbook secure from all however the main stepped forward 'hacker'. And who, between THEM, is going to have an interest interior the workbook you created in Excel ? no longer very darn many....
