مطالب مرتبط با «vba code only works in debug mode» در back soft | نویسنده: استخدام کار
Code works in Excel Modules but not in ThisWorkbook module.
Vote count: 0 I have a very simple piece of VBA code to copy the value of a cell, open another workbook, and paste that cell value into the newly opened workbook. It works perfectly in a normal module. But when I run the code in the ThisWorkbook module, for the purpose of triggering it when the file is saved, the other workbook will not open. Simpler macros like opening a MsgBox work fine in ThisWorkbook, however. Another weird thing is that the code DOES work in ThisWorkbook if I am viewing the code. Anyone know why this might be happening? I'm ruing Excel 2010. Code is below: Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim rangetocopy As St...
ادامه مطلب
