Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() In my spreadsheet I have created some custom views in which certain columns are hidden. Switching between views works OK until I protect the worksheet. Once protection has been applied however, I start to run into problems. If I attempt to switch views, I receive the Microsoft Excel error message: "Some view settings could not be applied". The hidden columns remain hidden, even though the view was saved with these columns being displayed. A further problem I am having is that with buttons on my spreadsheet that I have assigned to macros. If I resize the buttons in one view (and save the view), then they completely change size in the other custom views. Is there a way that I can get aroound this? Many thanks in anticipation to anybody out there who can help. -- AlanMagpie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regional Settings | Excel Discussion (Misc queries) | |||
how do I display a worksheeet in full screen view | Excel Discussion (Misc queries) | |||
Possible to view spreadsheets without scroll bars? | Excel Discussion (Misc queries) | |||
Page view vs. Print View | New Users to Excel | |||
There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) |