PC Review


Reply
Thread Tools Rate Thread

Call macro in worksheet from userform?

 
 
Ed from AZ
Guest
Posts: n/a
 
      12th Sep 2007
How do I call and run a macro contained in worksheet code from a
userform button code? I tried variations of
Run wkb("MASTER!SetNewHeader")
but nothing worked.

Ed

 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      12th Sep 2007
Is the userform part of the spreadsheet or is it part of an addin or a
seperate spreadsheet? It's hard to tell from your post.
--
HTH...

Jim Thomlinson


"Ed from AZ" wrote:

> How do I call and run a macro contained in worksheet code from a
> userform button code? I tried variations of
> Run wkb("MASTER!SetNewHeader")
> but nothing worked.
>
> Ed
>
>

 
Reply With Quote
 
Ed from AZ
Guest
Posts: n/a
 
      12th Sep 2007
Sorry, Jim. The form is in the same workbook as the worksheet and
macro.

Ed


On Sep 12, 11:06 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com> wrote:
> Is the userform part of the spreadsheet or is it part of an addin or a
> seperate spreadsheet? It's hard to tell from your post.
> --
> HTH...
>
> Jim Thomlinson
>
>
>
> "Ed from AZ" wrote:
> > How do I call and run a macro contained in worksheet code from a
> > userform button code? I tried variations of
> > Run wkb("MASTER!SetNewHeader")
> > but nothing worked.

>
> > Ed- Hide quoted text -

>
> - Show quoted text -



 
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: how to create label forms inside the worksheet not userform HammerJoe@gmail.com Microsoft Excel Programming 2 26th Jun 2008 07:37 AM
Call Worksheet_Change macro in another worksheet =?Utf-8?B?RnJlZGR5?= Microsoft Excel Programming 6 29th Oct 2006 07:16 PM
Macro to call-up UserForm =?Utf-8?B?TXIuIEcu?= Microsoft Excel Worksheet Functions 0 24th Aug 2006 09:24 AM
call a macro in another worksheet? =?Utf-8?B?R2VvcmdlIENvbmFyZA==?= Microsoft Excel Programming 2 16th May 2005 08:38 PM
how to call a macro from a worksheet event? lopsided Microsoft Excel Programming 5 16th Dec 2003 10:28 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:05 PM.