De-Attach Macro?? Is there any way?

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
>>>news:[email protected]...
>>>
>>>>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

Sure:

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 <[email protected]>,
"marika1981" <[email protected]> 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????

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" <[email protected]> wrote in message
> >>>news:[email protected]...
> >>>
> >>>>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

I see the microsoft.public.excel.macintosh messages when I compile my
monthly ng stats. Most of the posts are announcements from MS that say:

The new, improved newsgroup for this forum is:
microsoft.public.mac.office.excel

So you should listen to JE!

Dave Peterson wrote:
> 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" <[email protected]> wrote in message
>>>>>news:[email protected]...
>>>>>
>>>>>
>>>>>>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
>
>


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

Yes, ma'am.

Debra Dalgleish wrote:
>
> I see the microsoft.public.excel.macintosh messages when I compile my
> monthly ng stats. Most of the posts are announcements from MS that say:
>
> The new, improved newsgroup for this forum is:
> microsoft.public.mac.office.excel
>
> So you should listen to JE!
>

--

Dave Peterson

Old newsgroups never die...

In article <[email protected]>,
Dave Peterson <[email protected]> wrote:

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

I understand that in general, but I thought that MS would stop carrying it (kind
of like when worksheet.functions replaced worksheetfunctions (replaced in MS
land, added to in the real world).)

JE McGimpsey wrote:
>
> Old newsgroups never die...
>
> In article <[email protected]>,
> Dave Peterson <[email protected]> wrote:
>
> > That older one still shows up when I search for Excel. But I'd didn't
> > actually
> > connect to it to retrieve the headers.

--

Dave Peterson

The philosophy seems to be that it's better to keep the ng around on the
server, posting redirection notices, than to have an abandoned group
with their name on it out in usenet-space gathering disgruntled
posters...

If that's the case, it seems like a reasonable strategy.

worksheetfunctions, IIRC, was replaced because the name doesn't meet the
RFC length criteria.

In article <[email protected]>,
Dave Peterson <[email protected]> wrote:

> I understand that in general, but I thought that MS would stop carrying it
> (kind
> of like when worksheet.functions replaced worksheetfunctions (replaced in MS
> land, added to in the real world).)

That makes sense, too.

But then it confuses me when I search for just the newsgroup names <vbg>.

JE McGimpsey wrote:
>
> The philosophy seems to be that it's better to keep the ng around on the
> server, posting redirection notices, than to have an abandoned group
> with their name on it out in usenet-space gathering disgruntled
> posters...
>
> If that's the case, it seems like a reasonable strategy.
>
> worksheetfunctions, IIRC, was replaced because the name doesn't meet the
> RFC length criteria.
>
> In article <[email protected]>,
> Dave Peterson <[email protected]> wrote:
>
> > I understand that in general, but I thought that MS would stop carrying it
> > (kind
> > of like when worksheet.functions replaced worksheetfunctions (replaced in MS
> > land, added to in the real world).)

--

Dave Peterson