Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help!!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you both so much for your help - I know I'm going to sound totally thick here - but to assign the macro by going macro/record new macro?? How do I get to type in the macro as advised

    Sorry - I havn't had alot of experience with macros - as I am sure that you can tell

    Thanks for your help

    Trust

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Oregon
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    From the Tools menu select Macro, then record new Macro. It will bring up a pop up screen that will prompt you for a macro name and a hot key ( a key that when you hold down the Ctrl key and hit the key you select as the hot key will run the macro) Once you do that hit "OK" and you do whatever you want recorded then press the stop record button which it provides for you.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Oregon
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry I just read your other post and saw what you are trying to do. Right click on the sheet tab and select "view code" on the left side of the screen you will see a project view of your work book right click in that section and select "insert" then select "Module". You type your macro into that module you just created you can tie your button to it when you are done just like a regular macro that has been recorded.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •