Excel 2008 : Protected Workbook Turns on Gridlines

**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]

**Bobbbo** · 05-13-2010, 06:32 PM

I agree with all you said, but do you a solution for my problem?

**Richard Buttrey** · 05-13-2010, 07:09 PM

In short and without macros, no.

And I say that because I can't replicate your problem on my Excel for Mac 2008 version. It works exactly as I would expect. i.e the status of these setting is preserved.

Is this a workbook that you save and open across a network and if so are you sure no one is resetting the gridlines and headers before you next open it?

Regards

**Bobbbo** · 05-13-2010, 07:13 PM

No the workbook is only on my computer and the only way I share it is by emailing it to someone. One more characteristic is it seems to happen when I have 2 windows open at the same time of the same workbook. One has one tab display the other has another.