Results 1 to 4 of 4

Thread: command button on spreadsheet (resolve)

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908

    command button on spreadsheet (resolve)

    how do i insert a command button on the spreadsheet itself?
    Last edited by Goh; Apr 14th, 2004 at 03:16 AM.

  2. #2
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    1.Right click a toolbar top of screen to get dropdown menu.
    2.Click Forms.
    3.Click the button in that toolbar then hold down left mouse button & drag in the worksheet to make your button.
    4.Right click the button to get format & Assign Macro opions.
    Regards
    BrianB
    -------------------------------

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    hi..thanks i have successfully create a button on the spreadsheet...ad some functions to it and run it...(and save it..)
    but when i open the file and click on the form , all the controls are disable..why/

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    i got it cuz i have put password to it!!....thanks!

Posting Permissions

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



Click Here to Expand Forum to Full Width