How would you ever know what sheets are authorized and what sheets are not? By
sheetname??

And what will you do when they get smart and rename the unauthorized sheet to
something that is authorized?



Brian wrote:

Thanks for the reply. I'm not worried about blocking this functionality from
VBA programmers, just the normal secretaries, and HR and.......

When you say add a hidden worksheet in the game workbook are you talking
about doing that per game per PC?

About adding an auto-open macro in personal.xls that checks for the
Unauthorized sheet, once again is that per game per PC?

"Susan" wrote:

i'm no guru, but...... i'd say it depends on how sophisticated your
users are. if they're the ones learning VBA & writing macros, then
it's going to be a lot harder. but for others......
for instance, my secretary loves the macros that **i** write, & uses a
lot of VBA, but knows nothing about how to get into them, get into the
VBA editor, or anything like that. for that person i'd simply insert
a hidden worksheet in the game workbook named UNAUTHORIZED & have an
auto-open macro in personal.xls that checks for the existence of that
sheet. if found, they get a message saying "this is a spreadsheet not
authorized for use during business hours." & have it close itself.

but that's assuming you know where all these game workbooks are, what
their names are, and that the users won't know how to get around that.
just my ideas.
:)
susan




On Feb 6, 2:37 pm, Brian wrote:
I wouldn't mind setting a policy, but like others said if they rename a
game.xls file the game will still work. That and there are hundreds of games
written. There would be no way to keep up. I assume if I blocked all VBA
code from running in Excel, that would work, but I can't do that because
there are business reasons for VBA code.

I'm wondering if there is any commonality between the games that
distinguishes them from.....macros or other business legit code?



"JLGWhiz" wrote:
Here is mo

http://manageengine.adventnet.com/pr...ral/windows-se...

"Brian" wrote:

I'm a network administrator and I've been tasked with keeping our users from
being able to play games in Excel such as PacMan, Astroids........

Does anyone have any suggestions about how I can do this? - Hide quoted text -

- Show quoted text -



--

Dave Peterson