opening excel-sheet via hyperlink bug ??

peioz

Board Regular
Joined
Jul 17, 2002
Messages
78
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 ??
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Are your hyperlinks to worksheets (within the same workbook) or workbooks?

What happens when you click the Button?
 

peioz

Board Regular
Joined
Jul 17, 2002
Messages
78
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
 

peioz

Board Regular
Joined
Jul 17, 2002
Messages
78

ADVERTISEMENT

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

Board Regular
Joined
Jul 17, 2002
Messages
78
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

Well-known Member
Joined
May 19, 2002
Messages
2,916
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

Board Regular
Joined
Jul 17, 2002
Messages
78
Nothing in my home-sheet except hyperlinks.....

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

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,492
Messages
5,764,694
Members
425,231
Latest member
mramb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top