opening excel-sheet via hyperlink bug ??

[peioz]

I have an excel-"homepage"-sheet with several hyperlinks to other excel sheets, that I frequently use.

One of these sheets has a bunch of active-x checkboxes. with a button I can check all of these buttons.

Problem is, when I open this sheet via my "homepage"-sheet, the button doesn't function. when I "manually" open the sheet it DOES function....???

My code to check the buttons :

Sub checkall()

ActiveSheet.Unprotect
For Each MyShape In ActiveSheet.Shapes
If MyShape.Type = msoOLEControlObject Then
MyShape.Select
Selection.Object.Value = True
End If
Next

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub


Anyone any suggestions ??

 

[Andrew Poulsom]

Are your hyperlinks to worksheets (within the same workbook) or workbooks?

What happens when you click the Button?

 

[peioz]

My hyperlinks are to external excel files.

When I push the button to checkall, the macro DOES run (I inserted a message box that pops up), but it doesn't function anymore

 

[Andrew Poulsom]

What does:

MsgBox ActiveSheet.Name

tell you? Is that the sheet with your CheckBoxes?

 

[peioz]

The activesheet is the sheet with my checkboxes....

I made some similar home-page in word, and when I go to my sheet from there, it doesn't work either.

so it seems it is an office "problem"

 

[peioz]

It seems that, when I push my "checkall"-button, the button-values DO change. My buttons are checked, but excel doesn't update the buttons....

I can check this, because depending on the checked or not-checked value excel attaches a file to an e-mail.

So my check boxes are checked, but excel leaves them visually unchecked....

 

[Seti]

Is it possible you have some code set in your homepage workbook that prevents this? If it works OK when loaded normally, then I would suspect it could be something in your homepage code.

 

[peioz]

Nothing in my home-sheet except hyperlinks.....

I created a home-sheet from word, but it gives the same error.