| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Auto show properties dialog box on save
I have recently upgraded from Excel 2003 pro to 2007 pro.
In 2003 i was able to force the properties dialog box to be displayed on any save operation through the options, I cannot see any options in 2007 to achieve this. Any help would be apreciated. Regards CBA |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto show properties dialog box on save
Click the round icon top left, select Prepare, and then click Properties to
open the properties panel. You can also add an icon to your quick access toolbar. Click on the icon, select Excel options, select Customize. In chose commands from, select all, go all the way down to Properties, select it and click on Add. -- HTH Kassie Replace xxx with hotmail "cba" wrote: I have recently upgraded from Excel 2003 pro to 2007 pro. In 2003 i was able to force the properties dialog box to be displayed on any save operation through the options, I cannot see any options in 2007 to achieve this. Any help would be apreciated. Regards CBA |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto show properties dialog box on save
Hi Kassie,
Thanks for your reply. This opens the Properties dialog box manually, but does not force it to open on save, as I could in Excel 2003 through the options, has the option from 2003 been removed from 2007. Regards CBA "Kassie" wrote: Click the round icon top left, select Prepare, and then click Properties to open the properties panel. You can also add an icon to your quick access toolbar. Click on the icon, select Excel options, select Customize. In chose commands from, select all, go all the way down to Properties, select it and click on Add. -- HTH Kassie Replace xxx with hotmail "cba" wrote: I have recently upgraded from Excel 2003 pro to 2007 pro. In 2003 i was able to force the properties dialog box to be displayed on any save operation through the options, I cannot see any options in 2007 to achieve this. Any help would be apreciated. Regards CBA |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto show properties dialog box on save
So it seems, my friend! I do not find any indication that you can force it.
Unless of course you write a before save routine to call it? Alternatively, having a button on the quick access toolbar makes it easy to get to it. -- HTH Kassie Replace xxx with hotmail "cba" wrote: Hi Kassie, Thanks for your reply. This opens the Properties dialog box manually, but does not force it to open on save, as I could in Excel 2003 through the options, has the option from 2003 been removed from 2007. Regards CBA "Kassie" wrote: Click the round icon top left, select Prepare, and then click Properties to open the properties panel. You can also add an icon to your quick access toolbar. Click on the icon, select Excel options, select Customize. In chose commands from, select all, go all the way down to Properties, select it and click on Add. -- HTH Kassie Replace xxx with hotmail "cba" wrote: I have recently upgraded from Excel 2003 pro to 2007 pro. In 2003 i was able to force the properties dialog box to be displayed on any save operation through the options, I cannot see any options in 2007 to achieve this. Any help would be apreciated. Regards CBA |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto show properties dialog box on save
Thanks Kassie,
I will give it a go and write a before save script, it would be a big help to make it mandatory as in 2003. Thanks for your help Regards CBA "Kassie" wrote: So it seems, my friend! I do not find any indication that you can force it. Unless of course you write a before save routine to call it? Alternatively, having a button on the quick access toolbar makes it easy to get to it. -- HTH Kassie Replace xxx with hotmail "cba" wrote: Hi Kassie, Thanks for your reply. This opens the Properties dialog box manually, but does not force it to open on save, as I could in Excel 2003 through the options, has the option from 2003 been removed from 2007. Regards CBA "Kassie" wrote: Click the round icon top left, select Prepare, and then click Properties to open the properties panel. You can also add an icon to your quick access toolbar. Click on the icon, select Excel options, select Customize. In chose commands from, select all, go all the way down to Properties, select it and click on Add. -- HTH Kassie Replace xxx with hotmail "cba" wrote: I have recently upgraded from Excel 2003 pro to 2007 pro. In 2003 i was able to force the properties dialog box to be displayed on any save operation through the options, I cannot see any options in 2007 to achieve this. Any help would be apreciated. Regards CBA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Properties Tab on Doc Save | Excel Discussion (Misc queries) | |||
| Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
| Properties dialog box opens instead of a workbook | Excel Discussion (Misc queries) | |||
| Properties window show nothing for a userform | Excel Discussion (Misc queries) | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
