Can't comment without looking at the actual files, but hope the workbook
you are trying to open is an excel 2003- version, and that you have
modified the .xlsm above to xls
Sam
On Fri, Nov 18, 2011 at 2:02 AM, TAschefler wrote:
> Thanks Sam and Paul for the responses.
>
> I actually found code
Thanks Sam and Paul for the responses.
I actually found code on a site that will do exactly what i am looking
for. It verifies username and forces macros as well. The code works
great when I test it out on my computer...(using Excel 2010/WIN7).
When I set up for an employees computer (he is usin
And for that you could use ENVIRON$("USERNAME")
Regards,
Sam
On Mon, Nov 14, 2011 at 6:58 PM, Paul Schreiner wrote:
> If you want to tie it to the WORKSTATION, then here's what I'd suggest:
>
> First, send him a file that contains the macro:
>
> Sub auto_open()
> If (Sheets(1).Range("A1").Va
If you want to tie it to the WORKSTATION, then here's what I'd suggest:
First, send him a file that contains the macro:
Sub auto_open()
If (Sheets(1).Range("A1").Value = "") Then Range("A1").Value =
Environ$("computername")
End Sub
and have him save it and return it to you
(that will give y
Be advised that this approach would only prevent "Aggies" or people who
don't know how to use excel, from seeing all sheets even if protected with
VERYhidden thru code. Suggest each have their own workbook and you get data
as needed from it thru a macro.
Don Guillett
SalesAid Software
dguill
