+ Reply to Thread
Results 1 to 1 of 1

Automatic Calculation of Workbookname() and other functions

  1. #1
    Registered User
    Join Date
    Nuenen, The Netherlands

    Question Automatic Calculation of Workbookname() =>come on experts ! TOO DIFFICULT ?


    I am using some functions in excel to show the workbookname, username, company and sheetname in my spreadsheets.

    I have used the following statements:

    Function workbookname() As String
    'returns the workbook name of the cell
    workbookname = Application.Caller.Parent.Parent.Name
    End Function

    Function SHEETNAME() As String
    ' Returns the sheet name for string
    SHEETNAME = Application.Caller.Parent.Name
    End Function

    Function USER()
    ' Returns the users name
    USER = Application.UserName
    'USER = UCase(USER)
    End Function

    Function COMPANY()
    'returns the name of the company
    COMPANY = Application.OrganizationName
    End Function

    These staments are located in module1 of my personalstartworkbook which opens automatically when I start excel.

    My problem is that when the for example workbookname changes it does not automatically update the function workbookname(). I have to put the cursor on the cell en press F2 and return to update the value. Offcourse this is useless.

    Anyone having a suggestion to solve this ?

    Ronald de Vries
    Last edited by Ronald de Vries; 03-03-2005 at 08:38 AM. Reason: no response

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1