float menu open in the last week always

to always open  in the last week

here the file
29076215a--6-_87878.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
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
1
 
Martin LissOlder than dirtCommented:
Can you post the workbook that already has the rest of the buttons?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is you look in week 52 there are there
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Martin LissOlder than dirtCommented:
In any case try this. It will show you the last week every time you open the workbook.
29076815.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

one question

where inthe code i have to make that adjustment??
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Best Expert Always !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.