Consulting

Results 1 to 3 of 3

Thread: Help with Command Butttons - Keep them from Resizing

  1. #1

    Help with Command Butttons - Keep them from Resizing

    Hello,

    I wanted to know if someone could assist me with the use of command buttons.

    I am using the buttons directly on the worksheet of a workbook. I ran into two problems:

    (A) The buttons keeps resizing, either making the wording on the command shrink or get bigger.

    (B) Another user opened the same workbook I was using and their buttons went away.

    What properties can I set to keep the buttons from re-sizing? Is there any reason why the buttons disappeared in another excel user's workbook?

    Thanks in advance

  2. #2
    VBAX Contributor
    Joined
    May 2008
    Location
    bangalore
    Posts
    199
    Location
    wel i think ur using form control button

    use activex control button..

  3. #3
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    Set the property to Do Not Move or Resize with Cells.

Posting Permissions

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