float menu open in the last week always

ADRIANA P
ADRIANA P used Ask the Experts™
on
to always open  in the last week

here the file
29076215a--6-_87878.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin Liss"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Can you post the workbook that already has the rest of the buttons?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

is you look in week 52 there are there
Martin Liss"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
In any case try this. It will show you the last week every time you open the workbook.
29076815.xlsm
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

one question

where inthe code i have to make that adjustment??
"Life would be infinitely happier if we could only be born at the age of eighty and gradually approach eighteen." - Mark Twain
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Here is your workbook modified. The code is in ThisWorkbook

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
OldestWeek
End Sub

Open in new window

29076815a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Best Expert Always !!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial