Skip to content

A question for the Excel wizzards here...

Featured Replies

  • Administrators

Opening a new sheet a colleague would like to have the username (networked environment) populate field, for arguments sake lets say A1.

Scenario is user a downloads sheet and opens it, say it's a new PO form. One of the many fields is requesting user, this should be prepopulated by the forms author...

So wizzards of the underworld, how in gods name does one do this?

He's found out how to get an alert up (I think he said he had, bad phone line), any examples would be greatly appreciated.

Ta.

=GetKeyValue("My Computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer","Logon User Name")

Or summat like that - do a search on the =GetKeyValue() fn

Be careful using it cos if someone else opens the file it'll put their details in :D

Create an account or sign in to comment

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.