Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of macro
buttons (without deleting the buttons). I've deleted all the macros, but the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!

Marika,

If they are shapes, then try

Sub Macro3()
Dim myShape As Shape
For Each myShape In ActiveSheet.Shapes
myShape.OnAction = ""
Next
End Sub

HTH,
Bernie
MS Excel MVP

"marika1981" wrote in message
...
Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of
macro
buttons (without deleting the buttons). I've deleted all the macros, but
the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!

Marika,

If the buttons run macros, what good would they be without the macros?
That's how the buttons get stuff done -- they run macros.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"marika1981" wrote in message
...
Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of
macro
buttons (without deleting the buttons). I've deleted all the macros, but
the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!

Good question. I'm working on a Mac and the people who need to see the
project/spreadsheet I've created are working on PCs. When I send them the
file or give it to them on cdrom, they can't open the file. As such, I
wanted to get rid of the macros just so they could see the file and its
layout.

Certainly, the MORE CENTRAL question would be: do you know why macros
created on a Mac (Excel version 10.1.0) wouldn't open on a PC running Excel
2000? The tech people think it might be a security issue that can be changed
on the macros.....

Please let me know if you have any thoughts - I'm in deep trouble.....

Thanks so very much..



"Earl Kiosterud" wrote:

Marika,

If the buttons run macros, what good would they be without the macros?
That's how the buttons get stuff done -- they run macros.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"marika1981" wrote in message
...
Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of
macro
buttons (without deleting the buttons). I've deleted all the macros, but
the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!

There are a few Mac users who hang around here, but if you don't get a good
answer soon, you may want to post in the macintosh newsgroup.

microsoft.public.excel.macintosh


marika1981 wrote:

Good question. I'm working on a Mac and the people who need to see the
project/spreadsheet I've created are working on PCs. When I send them the
file or give it to them on cdrom, they can't open the file. As such, I
wanted to get rid of the macros just so they could see the file and its
layout.

Certainly, the MORE CENTRAL question would be: do you know why macros
created on a Mac (Excel version 10.1.0) wouldn't open on a PC running Excel
2000? The tech people think it might be a security issue that can be changed
on the macros.....

Please let me know if you have any thoughts - I'm in deep trouble.....

Thanks so very much..

"Earl Kiosterud" wrote:

Marika,

If the buttons run macros, what good would they be without the macros?
That's how the buttons get stuff done -- they run macros.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"marika1981" wrote in message
...
Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of
macro
buttons (without deleting the buttons). I've deleted all the macros, but
the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!




--

Dave Peterson

I think the active Mac newsgroup is:

microsoft.public.mac.office.excel

Dave Peterson wrote:
There are a few Mac users who hang around here, but if you don't get a good
answer soon, you may want to post in the macintosh newsgroup.

microsoft.public.excel.macintosh


marika1981 wrote:

Good question. I'm working on a Mac and the people who need to see the
project/spreadsheet I've created are working on PCs. When I send them the
file or give it to them on cdrom, they can't open the file. As such, I
wanted to get rid of the macros just so they could see the file and its
layout.

Certainly, the MORE CENTRAL question would be: do you know why macros
created on a Mac (Excel version 10.1.0) wouldn't open on a PC running Excel
2000? The tech people think it might be a security issue that can be changed
on the macros.....

Please let me know if you have any thoughts - I'm in deep trouble.....

Thanks so very much..

"Earl Kiosterud" wrote:


Marika,

If the buttons run macros, what good would they be without the macros?
That's how the buttons get stuff done -- they run macros.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"marika1981" wrote in message
...

Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of
macro
buttons (without deleting the buttons). I've deleted all the macros, but
the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

That older one still shows up when I search for Excel. But I'd didn't actually
connect to it to retrieve the headers.

(JE posted a similar response to a similar post that pointed to a similar dead
newsgroup.)

<hehe

Debra Dalgleish wrote:

I think the active Mac newsgroup is:

microsoft.public.mac.office.excel

Dave Peterson wrote:
There are a few Mac users who hang around here, but if you don't get a good
answer soon, you may want to post in the macintosh newsgroup.

microsoft.public.excel.macintosh


marika1981 wrote:

Good question. I'm working on a Mac and the people who need to see the
project/spreadsheet I've created are working on PCs. When I send them the
file or give it to them on cdrom, they can't open the file. As such, I
wanted to get rid of the macros just so they could see the file and its
layout.

Certainly, the MORE CENTRAL question would be: do you know why macros
created on a Mac (Excel version 10.1.0) wouldn't open on a PC running Excel
2000? The tech people think it might be a security issue that can be changed
on the macros.....

Please let me know if you have any thoughts - I'm in deep trouble.....

Thanks so very much..

"Earl Kiosterud" wrote:


Marika,

If the buttons run macros, what good would they be without the macros?
That's how the buttons get stuff done -- they run macros.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"marika1981" wrote in message
...

Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of
macro
buttons (without deleting the buttons). I've deleted all the macros, but
the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????

Please reply if you know!!

Thank you!





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson

Su

Public Sub DeAttach()
Dim ws As Worksheet
Dim sh As Shape
For Each ws In ActiveWorkbook.Worksheets
For Each sh In ws.Shapes
sh.OnAction = ""
Next sh
Next ws
End Sub




In article ,
"marika1981" wrote:

Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of macro
buttons (without deleting the buttons). I've deleted all the macros, but the
buttons still look for the non-existing macros.

Is there any way to keep the buttons but delete the macros????