| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to record a sheet change showing row column sheet name and date?
Hi all, I have added the line Dim oWBAudit as Object and the program now works but is trying to open the tracking workbook twice and then the code breaks with a "Method of workbook open failed" Any refinements to cure this? I would prefer for the tracking workbook not to open but if this has to be the case could it save and close straight away? Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=266360 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
![Simon Lloyd[_583_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
