Button fails to call macro when open an Excel via Intranet

Hi all,

Can someone help me with my with this problem.

I have an Excel file with a button to run a small macro: unhide and displys
worksheets. It works when the file is opened with Excel.

The macro is simple:

Sub Button1_Click()
Sheets("FF").Visible = True
Sheets("FF").Select
Range("C1").Select
End Sub

I need to open it from an intranet site. When user selects the file, the web
app
retrieves the file and responses to open an Excel file.

But on the intrenet I get the following error massage
"The macro "GenerateResource.aspx?ResourceID=7508'!Button1_Cl ick' cannot be
found"

Can anyone help.

Thanks in advance
Adam

Can any one help with this as it is needed urgently

Thanks

"tigertax" wrote:

Hi all,

Can someone help me with my with this problem.

I have an Excel file with a button to run a small macro: unhide and displys
worksheets. It works when the file is opened with Excel.

The macro is simple:

Sub Button1_Click()
Sheets("FF").Visible = True
Sheets("FF").Select
Range("C1").Select
End Sub

I need to open it from an intranet site. When user selects the file, the web
app
retrieves the file and responses to open an Excel file.

But on the intrenet I get the following error massage
"The macro "GenerateResource.aspx?ResourceID=7508'!Button1_Cl ick' cannot be
found"

Can anyone help.

Thanks in advance
Adam