Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-18 Thread Sam Mathai Chacko
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

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-17 Thread TAschefler
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

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-14 Thread Sam Mathai Chacko
can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *--------- > > > -- > *From:* TAschefler > *To:* MS EXCEL AND VBA MACROS > *Sent:* Mo

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-14 Thread Paul Schreiner
n, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: TAschefler To: MS EXCEL AND VBA MACROS Sent: Mon, November 14, 2011 8:49:44 AM Subject: $

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-14 Thread dguillett1
lesAid Software dguille...@gmail.com -Original Message- From: TAschefler Sent: Monday, November 14, 2011 7:49 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Open Worksheet if Filepath verified I have an excel file that I want to give to an employee that will only run if it is on their

$$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-14 Thread TAschefler
I have an excel file that I want to give to an employee that will only run if it is on their computer. I am looking for a macro that would show perhaps an introduction page and if the file name/path matches maybe a cell on the introduction page then it will unhide the (3 sheets) that the employees