Search results for query: *

Greetings, Using: excel 2003 - vba with a little bit of knowledge Creation: I have created an "standalone" version of several interactive workbooks. With standalone I mean that, in workbook_open, all sheetfunctions (scrollbars, tabs, etc.) and commandbars are disabled, my commandbar is docked...

using excel 2003-vba since the autofilter is turned on and off by the same command I need to check if autofilter is activated on a sheet or not to subsequently activate it when it's not. is there a way to check this? tried: if selection.autofilter = false then selection.autofilter but...

using excel 2003-vba I have a database with a lot of code behind it to automize all. To protect the database and the code behind it against userinterference I have gave excel a 'standalone' appearance by activating a fullscreen mode and disabling the active menubar and fullscreen-menubar...

using excel 2003 I have made a customized commandbar. Now I like to add an customized icon to the buttons on this commandbar. Manually I can use Tools/Toolbars/Commands/Modify selection/edit button image to create an icon which excel 'remembers'. Yet I can't find a way to accomplish this in...

Using VBA - Excel 2003 in short: 1 worksheet, lots of records on rows. trying to get 1 or more records first I used: while activecell.value <> searchvalue then activecell.offset(1,0).select wend works perfectly but with a large database it becomes slow on the less...

Using Excel 2003-vba, I have a userform with several textboxes for descriptions and named them tbxDescription1 to tbxDescription9 Now I need to loop through them in serveral occassions and tried to accomplish that by following code dim obj as object for cnt = 1 to 9 cnt$ = right(str(cnt),1)...