PC Review


Reply
Thread Tools Rate Thread

how and where to save a macro

 
 
=?Utf-8?B?UGF1bA==?=
Guest
Posts: n/a
 
      19th Oct 2007
I am trying to create a current macro to stop the web toolbar from popping up
whenever I click on links in outline mode in World 2000. I can paste in the
following into the Visual basic editor, but then I'm stuck

Public Sub BanishWebToolbar()

CommandBars("Web").Enabled = False
'Change 'False' to 'True' to re-enable the Toolbar

End Sub

What do I do with this? None of the sites I looked at told me. Do I save
it as a word doc? Where? I've done macros before by clicking, but never by
copying/pasting.

Thanks in advance.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?UGF1bA==?=
Guest
Posts: n/a
 
      19th Oct 2007
OK I eliminated the word "public" from below, but I'm still stuck.

"Paul" wrote:

> I am trying to create a current macro to stop the web toolbar from popping up
> whenever I click on links in outline mode in World 2000. I can paste in the
> following into the Visual basic editor, but then I'm stuck
>
> Public Sub BanishWebToolbar()
>
> CommandBars("Web").Enabled = False
> 'Change 'False' to 'True' to re-enable the Toolbar
>
> End Sub
>
> What do I do with this? None of the sites I looked at told me. Do I save
> it as a word doc? Where? I've done macros before by clicking, but never by
> copying/pasting.
>
> Thanks in advance.

 
Reply With Quote
 
garfield-n-odie [MVP]
Guest
Posts: n/a
 
      19th Oct 2007
See http://www.gmayor.com/installing_macro.htm .

Paul wrote:

> I am trying to create a current macro to stop the web toolbar from popping up
> whenever I click on links in outline mode in World 2000. I can paste in the
> following into the Visual basic editor, but then I'm stuck
>
> Public Sub BanishWebToolbar()
>
> CommandBars("Web").Enabled = False
> 'Change 'False' to 'True' to re-enable the Toolbar
>
> End Sub
>
> What do I do with this? None of the sites I looked at told me. Do I save
> it as a word doc? Where? I've done macros before by clicking, but never by
> copying/pasting.
>
> Thanks in advance.


 
Reply With Quote
 
=?Utf-8?B?UGF1bA==?=
Guest
Posts: n/a
 
      20th Oct 2007
Great, Garfield. That did it. Got it bookmarked in case I forget.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Save without the Save Message =?Utf-8?B?RWxsZW4gRw==?= Microsoft Excel Misc 4 23rd Feb 2007 08:52 PM
"Save" macro problem, still prompted to save when closing workbook (?) StargateFanFromWork Microsoft Excel Programming 8 13th Sep 2006 04:49 PM
ASP: Open Excel File with Macro, Allow Macro to run, and then save =?Utf-8?B?ZGVsZ2Fkb3MxMjk=?= Microsoft Excel Programming 0 10th Mar 2005 09:35 PM
Re: Can a VBA macro save a workbook without the macro? Ron de Bruin Microsoft Excel Misc 0 15th Mar 2004 06:59 PM
Prompted to save changes after macro save - why? Izar Arcturus Microsoft Excel Programming 2 10th Dec 2003 09:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:36 AM.