Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Protection - restrict macro exposure to the workbook, VBAProject

How do you prevent external macros (not held in the workbook VBAProject)
running in a workbook?

i.e. Is it possible to restrict macro exposure to those held in the workbook?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 156
Default Protection - restrict macro exposure to the workbook, VBAProject

not really,

normally the workbook and all it's objects is exposed to any VBA code that
has access.

So you could protect the workbook to prevent it being opened unless the
password is used.

HTH

Philip

"JB2005" wrote:

How do you prevent external macros (not held in the workbook VBAProject)
running in a workbook?

i.e. Is it possible to restrict macro exposure to those held in the workbook?

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
VBAProject still visible after closing workbook Terry Excel Programming 3 May 29th 06 09:45 PM
workbook Protection Toggle Macro Just Learning Excel Discussion (Misc queries) 3 August 30th 05 11:03 PM
Workbook/Macro/Worksheet Protection... Murph Excel Programming 2 June 28th 05 03:30 PM
customise button(macro) on toolbar / workbook protection tango Excel Programming 1 October 21st 04 10:49 AM
More than 1 workbook in a VBAProject R Avery Excel Programming 8 May 27th 04 06:40 PM


All times are GMT +1. The time now is 09:36 PM.

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

About Us

"It's about Microsoft Excel"