Phelony
08-25-2011, 06:22 AM
Hi guys
I've got a function for usernames, pretty basic:
Function getusername()
getuser = (Environ$("Username"))
getusername = getuser
End Function
and works fine when used in it's spreadsheet.
So then I've got the formula ="Welcome "&getusername()
Problem is, when the spreadsheet is e-mailed or opened on any other computer, it's not updating, so this thing is going all over the place with my name instead of the actual users name.
I've tried putting in a calculate order when the workbook opens, calculation for the sheet is set to automatic and I'm now a bit :banghead: as to why it's not updating itself.
Any ideas? :dunno
Phel
I've got a function for usernames, pretty basic:
Function getusername()
getuser = (Environ$("Username"))
getusername = getuser
End Function
and works fine when used in it's spreadsheet.
So then I've got the formula ="Welcome "&getusername()
Problem is, when the spreadsheet is e-mailed or opened on any other computer, it's not updating, so this thing is going all over the place with my name instead of the actual users name.
I've tried putting in a calculate order when the workbook opens, calculation for the sheet is set to automatic and I'm now a bit :banghead: as to why it's not updating itself.
Any ideas? :dunno
Phel