You may have to register before you can post: click the register link above to proceed. Any help would be greatly appreciated! =) Code: Sub ConvertCSV() ' selects the Manual_Template Worksheet. But as soon as I run the 2nd line, it goes straight to the event. Just add the following to your toggle buttons click event, and you will get the correct effect. http://www.mrexcel.com/forum/excel-questions/577734-enableevents-%3D-true-does-not-work.html
If you're having a computer problem, ask on our forum for advice. I looked up help which > suggested I need an EventClassModule to instantiate the Application, > which I have done, but to no avail. > > Any help appreciated. > > One issue that I see is that in the cancel situation, the Do Loop continues. What I have is a program that creates several workbooks.
Thanks Cnsleepy Ask Your Own Question Vba Open File/run Code/close & Save/open Next File? - Excel Excel Forum Hello, I have a number of different files that I often need to We apologize in advance for any inconvenience this may cause. Any help or guidance is much appreciated. Ask Your Own Question Disable Save & Save As Excel 2007 - Excel Excel Forum Hi Im hoping someone could help me out here...what Im looking for is help with disable
I will be interested if anyone has a better method because I personally think that it is messy. The code I am using is: With Destwb .SaveAs strFilePath & strFileName, FileFormat:=xlText, CreateBackup:=False .Close End With As always, your help is much appreciated! To save a copy, click OK, then give the workbook a new name in the Save As dialog box." How can I get it react the same way to the Save End Sub siirial, Oct 20, 2011 #5 Advertisements Show Ignored Content Want to reply to this thread or ask your own question?
What am I not doing? Set its value such as gbExternal = true
Matthew Dodds, Apr 17, 2007, in forum: Microsoft Excel Programming Replies: 1 Views: 231 Peter T Apr 17, 2007 application.EnableEvents = false not disabling events Brad, Feb 13, 2008, in forum: I have set up code which allows me to be able to SaveAs in other locations while still keeping all sheets hidden upon saving. Would the members of an online imageboard (or any community) be able to build a post-apocalytic society upon their reputation? Yes, my password is: Forgot your password?
If an unauthorized person is viewing the wkbk (i.e. You may have to register before you can post: click the register link above to proceed. Or put <>1 if you need the oposit thing to happen. - Mangesh "Paul Martin"
More About Us... I also want to save it to a shared folder on a network, but in this case I want it to be write protected. PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick
Dev Center Explore Why Office? Ask Your Own Question Disable Save Option On Workbook Except For Named Macro's - Excel Excel Forum Hi, I want to disable all save option's in a workbook but still allow Rick Rothstein, Oct 28, 2009 #6 ras Guest Thx. It first fires up the workbook one, the the application one, and finally the sheet one.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required Sub Workbook_BeforeSave(ByVal SaveasUI As Boolean, Cancel As Boolean) HideSheets If SaveasUI = False Then Cancel = True Application.EnableEvents = False Else Application.EnableEvents = True End If If Sheets("CloseVariable").Range("CloseVar").Value = "False" Then Reply With Quote Sep 9th, 2011,10:12 AM #2 Weaver Board Regular Join Date Sep 2008 Posts 5,195 Re: EnableEvents = True does not work Personally, I'd include it at every point However, if the BeforeSave Event is fired by any other route such as the BeforeClose Event (i.e.