gringo287
06-01-2012, 06:04 AM
Hi,
I need a little advise, on what can and cant be done with userforms. Mainly relating to issues around having one copy that all users have access to from a shared drive (that is currently running at 99% capacity), or if it is possible for all users to have their own copy with would eliminate the issue with space but more than likely cause more issues elsewhere.
ill bullet point my questions/query
The userform currently tracks/creates the users daily performance stats, based on their input and these stats can be emailed (with a really cool macro) to the manager at the end of the day.
These stats are wiped at the start of each new shift.
My aim is to create a weekly average that would be created automatically based on the users current stats plus the previous day/days stats.
Skipping over the obvious issue with the bursting to the brim shared drive.. is it possible to enable a useform to not have to depend on the file name, to open without errors.
My worry is that it is far too easy for a user to end up changing the file name and breaking the userform.
Is there such a thing as a macro that would prevent the users from being able to change the file name.
I need a little advise, on what can and cant be done with userforms. Mainly relating to issues around having one copy that all users have access to from a shared drive (that is currently running at 99% capacity), or if it is possible for all users to have their own copy with would eliminate the issue with space but more than likely cause more issues elsewhere.
ill bullet point my questions/query
The userform currently tracks/creates the users daily performance stats, based on their input and these stats can be emailed (with a really cool macro) to the manager at the end of the day.
These stats are wiped at the start of each new shift.
My aim is to create a weekly average that would be created automatically based on the users current stats plus the previous day/days stats.
Skipping over the obvious issue with the bursting to the brim shared drive.. is it possible to enable a useform to not have to depend on the file name, to open without errors.
My worry is that it is far too easy for a user to end up changing the file name and breaking the userform.
Is there such a thing as a macro that would prevent the users from being able to change the file name.