Excel Macros - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 09-16-2005, 12:11 PM   #1 (permalink)
Junior Techie
 
Join Date: May 2005
Posts: 96
Default Excel Macros

Hi there,
Trying to support a user, and Im not sure about Macros and excel. Basically, under one user account, the spreadsheet wont open because it points to file locations that she does not have access to. Is there a way to look in Excel and see where all the Macros point to? I did not create the spreadsheet, someone else did. Any advise would be appreciated. Thanks
__________________

Brain is offline  
Old 09-16-2005, 12:18 PM   #2 (permalink)
S e c u r e d
 
Join Date: Feb 2005
Location: Somewhere Sunny
Posts: 3,760
Default

You can check the macros through tools/macros. You might also need to set the security level on the macros through options/security/macros. set it to low.
__________________

__________________
brady is offline  
Old 09-16-2005, 12:23 PM   #3 (permalink)
Junior Techie
 
Join Date: May 2005
Posts: 96
Default

I can seem to get into there, its the same as pressing Alt + F8, but once in there the only buttons that I am able to click are Run and Cancel. Is there a way to look where the Macros listed point to?
Brain is offline  
Old 09-16-2005, 12:27 PM   #4 (permalink)
S e c u r e d
 
Join Date: Feb 2005
Location: Somewhere Sunny
Posts: 3,760
Default

Search your clients machine for .vcm's. Macros are embedded C++ into a .vcm file.
__________________
brady is offline  
Old 09-16-2005, 12:27 PM   #5 (permalink)
S e c u r e d
 
Join Date: Feb 2005
Location: Somewhere Sunny
Posts: 3,760
Default

They are just basically automated tasks that alters views and interaction with files.
__________________
brady is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 09:38 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.