I have an Excel file called Installer.xls. This contains a macro which installs files depending on information entered by a user. At the end of the install procedure I wish the Installer.xls file to close itself and exit Excel. I have tried using application.qui t and activeworkbook. close, saved = true and it causes Excel to crash and recover the file.
I think this problem is because the macro does not get to the end of the sub procedure...
Badino
Last Activity: Feb 19 '07, 11:23 AM
Joined: Feb 9 '07
Location:
-
Annoying Macro problem - Is there a solution?
-
Badino started a topic How to make this code change the font colour to white if black cell colour is chosenin Visual BasicHow to make this code change the font colour to white if black cell colour is chosen
Hi,
Can someone tell me what to put in this code so that if a user selects 0 (Black) then make the font white (0) as my default colour is black on my Excel spreadsheet.
...Code:Private Type CHOOSECOLOUR lStructSize As Long hwndOwner As Long Hinstance As Long rgbResult As Long lpCustColors As String flags As Long lCustData As Long lpfnHook As Long lpTemplateName
No activity results to display