VB Objects not visible on worksheet

[Jon von der Heyden]

Hi,

I have built a model with a navigation sheet to make it easier for my users to select the worksheets thy need to access, and to print any combination thereof using check boxes and a cmd button.

It's fine for all but one of my users. The one in particular says he cannot even see any of the vb objects in that worksheet. Option boxes, check boxes and command butttons.

Anybody have any idea why this may be?

Thanks,
Jon

 

[lisauk5583]

Hiya,

This may not be the answer you are looking for, but if you're working on networked machines, the first thing to check is macro security. If his security is set to high, or has clicked disable macros upon the opening of the spreadsheet, no macros will be visible. Have a look at options - security.

Lisa

 

[staticbob]

Jon,

What version of Excel is the problem user on ?

Bob

 

[Jon von der Heyden]

Thanks, the user has checed the security level and it's on low. He's using 2003, the same version I used when building the model.

Furthermore, I've checked with him whether or not the sheet is protected and apparently it's not... V confused

Thanks,
Jon