Excel 2008 : Protected Workbook Turns on Gridlines

**Bobbbo** · 05-12-2010, 04:00 PM

I have a Workbook with all the sheets protected which includes having the Gridlines and Headings turned off. I also has the complete workbook Protected - Structure so hidden sheets cannot be opened. When I save the workbook and close it, when reopened the gridlines and headings turn back on on all the protected sheets! I can see in the Formatting palette that the gridline and head boxes are now checked even though they are gray from the sheet protection.

How do I prevent this from happening??

**Richard Buttrey** · 05-12-2010, 04:47 PM

Hi,

Just use the Workbook Open event in the Visual Basic Environment to turn them off when the workbook loads.

HTH

**Bobbbo** · 05-12-2010, 05:31 PM

Originally Posted by Richard Buttrey

Hi,

Just use the Workbook Open event in the Visual Basic Environment to turn them off when the workbook loads.

HTH

I need a little more clarity in what the Workbook Open event in the Visual Basic Envirnoment. I thought Visual Basic was used to write Macros which is no longer supported in office 2008.

**Richard Buttrey** · 05-12-2010, 05:49 PM

Hi.

If you're an Apple Mac user and have moved up to Excel for Mac 2008 then you are correct.

In their infinite wisdom MS dropped Visual Basic from that release. Having realised they've shot themselves in the foot there are rumours that it will be re-introduced in some future edition but that's only a rumour.

If you are not using Excel for Mac then post back.

Regards

**Bobbbo** · 05-13-2010, 11:14 AM

Yes, I am using the Mac 2008 version. And I do miss using Macros. So now everything has to be done with formulas that is far more difficult.

**Richard Buttrey** · 05-13-2010, 01:44 PM

Indeed!

Although I'm a great fan of the Apple Mac platform and use it for for just about everything else in my life, when it comes to Excel it is a very poor second cousin. Not only does the lack of right clicks and the non standard Fn keys drive me insane, it is nowhere near as productive as the Windows version. Particularly in the Visual basic Environment, where not only is some of the syntax different and several instructions sets are missing, but the autocomplete and syntax checking is non existent as is the Watch window. As a developer it is far more difficult to work with.

[/HobbyHorse]