Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filling a combobox (without being prompted to save the workbook EVERY time its opened
basically i am being prompted to save the workbook every single time it
opened and have narrowed it right down to the 'listfillrange' of combobox that i have. if i put anything into listfillrange then every time the workbook i loaded, even if nothing is done other than click the close button, i a prompted to save it due to changes. there has to be a way around this surely? i just cant imagine ever excel spreadsheet in the world that contains a vb combobox has t prompt users to save the workbook every single time. the information in the combobox is totally static and will never chang so i dont need any kind of dynamic way of filling it, i just need t get the values into the combobox without it doing this prompting al the time, its rediculous -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filling a combobox (without being prompted to save the workbook EVERY time its opened
Is this in a worksheet ?
If so, you could try the combo from the Forms toolbar -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filling a combobox (without being prompted to save the workbook EVERY time its opened
yup its on a worksheet. i cant use the forms one because the text in i
is miniscule and you cant change the font. the sheet has to be viewe at 40% zoom because its quite big so i have to be able to alter th font sizes etc so its visible -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
always prompted to save opened workbooks | Excel Discussion (Misc queries) | |||
Printing a workbook one row at a time filling in a form with the d | New Users to Excel | |||
How? Force Sheet1 to display each time the workbook is opened. | Excel Programming | |||
Disable Save As just for opened workbook | Excel Programming | |||
Save as CSV without being prompted | Excel Programming |