Excel 2007
I have a spreadsheet created by someone else with several buttons, each calls a macro. When I right click on the macro the last selection on the menu is 'Format Shape'. I have a need to create additional buttons, but on my buttons I do not get format shape. How can I get this option?
Thanks
arun soni
If your button is a command button you will not get format shape, is it a button or a shape on your sheet?
Not all forums are the same - seek and you shall find
Hi, Thanks for your prompt reply.
It is not a command button. Created from ..... Developer, controls, insert, buttons (Form control). I assign macros to these.
arun soni
Its a button, is there another way of doing this? I have attached the spreadsheet for reference.
The buttons in your workbook are from the Forms control toolbox.
And using the method you describe should create new buttons that you can assign a macro to.
Or you could just copy the existing buttons and re-assign a macro.
Andy thanks for your response.
I am able to assign macros successfully, I want to use format shape but do not get this option on new buttons I add to the spreadsheet, the originals have this when you right click. Any idea how I can get the 'Format Shape' option on the buttons.
Take a look at the attached, the buttons in yellow has this option, the non yellow do not.
arun soni
Your Frontend2.xls does not have a Yellow button.
All of the shapes that look like buttons are buttons and have the Format Control menu item.
If the menu item is Format Shape then the shape is an autoshape, of which there is one that looks like a button.
I apologise.
The buttons I am referring to are labelled 'RUN'. If you right click you will see the last option is Format Shape. Whereas the button marked GIT.... does not have this option.
arun
Your example has 7 buttons, labeled RUN,RUN,RUN,RUN,Button 5,Button 6,Button 7. And a shape which is a Pentagon Arrow autoshape.
Are we talking about the same file?
Yes Frontend2
The buttons marked RUN have the 'Format Shape' option when right click
The Button marked 'GIT.xls to CSV does not shoe 'Format Shape' option on right click.
Andy, are you opening this spreadsheet in Excel 2007? Using 2003 does give different result.
Moving post to correct forum!
Yes 2007.
Sorry but those button say Format Control.
Try downloading the file you posted and check whether the file is the same and that the problem persists.
I am sorry...... duh.....
Correct one attached
soniarum there's no attachment!
Sorry, exceeded 100k
Take 3...Zipped file attached
The last file contains autoshapes from the Drawing ToolBar with macros assigned, not Buttons from the Forms ToolBar or Controls toolBox
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Roy
That's completely new for me. How do I create this on same or new spreadsheet?
Insert > Shapes > Rounded Rectangle.
Apply Style, Subtle Effect Accent 6.
Edit text and add "Run" wording.
Right click and assign macro.
So easy when you know it.
Thanks a Ton
and apologies to all for uploading incorrect spreadsheet to begin with.
arun soni
(If it don't work first time, call it version 1.1)
Last edited by soniarun; 06-11-2008 at 06:18 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks