Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 253
Default Application Security Loses Control

Hi Paul,
I didn't had problem with macro security before.
I suggest you step(F8) trought your code with the locals window open and
check the value of your variables and see if one woudl be changeg by
something (...?).
For info, what is you current degree of security ?
Good luck
Regards,
JY

"Paul Mac" wrote in message
...
Hi Jean,

I have tried:

- Setting the wb Variable as you described
- Using the Open FileDIalog.show (then . execute)
- Just trying workbook.open all by its lonesome.

All with no luck. It appears that as soon as the workbook is called, it

stops the current code.

I have constructed a workaround by using the Application.Ontime method and

calling a sub-set of the code after the point where it stops.

Any other ideas would be great.

Paul.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I control what application opens a Hyperlink? Bikeman Excel Discussion (Misc queries) 0 May 25th 07 05:27 PM
What is the application control menu rw7402 New Users to Excel 0 October 31st 06 02:52 AM
Displaying MS Excel Chart control in ASP.NET Application oursmp Charts and Charting in Excel 0 April 20th 05 04:17 PM
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM
Application.OnUndo Questions - Loses Prior Undo's and Runs 1x Tom Ogilvy Excel Programming 0 August 27th 03 01:26 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"