both the Red X (top right), as well as right clicking the tab on the bottom and closing, or even by pressing ALT+F4??
I understand that there are a lot of threads on various sites with this question however i've been looking for 7 hours yet have no answers. Alot are around forms- this is not the case i simply dont want the user to manually close Excel, they must do it via my own close button (which is linked to a macro restoring some...
paul138
Last Activity: Feb 5 '10, 01:12 PM
Joined: Dec 10 '09
Location:
-
Thank you very much!!
just what i needed :-) -
List box selection leading to that selection being removed from the source.
Hi,
Please Help.
I have a list box containing 5 countries: England, Scotland, Ireland, Wales, Germany.....
When the user selects the country, and clicks ok, i want that country to be removed from the RowSource data (Sheet1, Cells C101:C105). However i dont know the code for this.
I dont want any rows to be removed, rather just a clear contents.
Please Help,
Thanks in adva... -
Code needed to Exit sub early depending on criteria.
Hi,
I have created an index in Excel that goes up by 1 everytime a macro is run. (cell c99 in Sheet1)
I.e. it starts at one, i run the macro and it now shows 2.
I wish to add some code to my macro which doesnt allow this addition to happen anymore, once my index number has reached 5, and for the macro to exit sub early.
So once the index reaches five, i wish for a message box to appear telling... -
list box- copy selected to seperate sheet
Hi People,
I have a listbox on a user form ,and want the user to select 1 country from it, then click an ok button.
When they click the OK button i want a macro to copy the name of the country into cell a1, in sheet1.
What would the code be for this?
Its easy i know, i just cant do it lol.
Please help.
Thanks in advance
No activity results to display
Leave a comment: