Dear All
i want to prepare an excel file with user restrictions -
i found the following macro code on the net
can anyone guide me
Macro Name} User Specific Macro
{Control Statement} IF
{Condition} User = Shireen
{Operator/function} USER( 'shireen' ) = 1
{Step} User Restriction - Shireen :(36 Iterations : M 09/2006; M 08/2009)
{Row} Row: History ( Attributes ) =
{Operator/function} ROW_INPUT( 0 )
{Row} Row: Statistical Forecast ( Attributes ) =
{Operator/function} ROW_INPUT( 1 )
IF
USER( <NAME1> ) = 1
OR
USER( <NAME2> ) = 1
<key figure>
ROW_INPUT( 0 )
ELSE
<key figure>
ROW_INPUT( 1 )
ENDIF
basically i am forwarding a confidential report to certain people - these
people may in turn forward the same to some other people - which i dont want
- so iw ant the macro to allow only selected users to open this file.
Here the username is the employee id - ( logging into the computer is
through this ID). the same id can be seen in the excel file properties under
the heading of "Author"
Please Help
--
Regards
Hemant Kalia
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
