Another command button... for zoom this time

**torontoguy** · 01-22-2009, 09:34 AM

I'd like to create a button that zooms to 45% or 100% (depending on current zoom)

(or 2 buttons... one to make it 45 and another to make it 100)

**royUK** · 01-22-2009, 09:46 AM

Try

Please Login or Register  to view this content.

**davesexcel** · 01-22-2009, 09:49 AM

So whats the question?
You already know how to make command buttons
Use the macro recorder to get the code

**torontoguy** · 01-22-2009, 09:51 AM

Originally Posted by davesexcel

So whats the question?
You already know how to make command buttons
Use the macro recorder to get the code

Alright thanks. Will remember that for next time.

Please Login or Register  to view this content.

seems that the CommandButton2.Caption isnt working for me :S

**davesexcel** · 01-22-2009, 10:03 AM

Please Login or Register  to view this content.

The periods get in the way

**torontoguy** · 01-22-2009, 10:08 AM

kk, ty for that. In the other button, the periods were there however... strange.

**royUK** · 01-22-2009, 10:14 AM

Originally Posted by torontoguy

kk, ty for that. In the other button, the periods were there however... strange.

Because in the other example I used the key word me

**torontoguy** · 01-22-2009, 10:40 AM

Ah

Got it. I havent used VBA in years and am definitely getting rusty.