Your code references the Activesheet, which is "Infromation" when the code is run.
The simplest fix is to activate the correct sheet. The more robust solution is to alter your code to use full references.
![]()
Private Sub CommandButton2_Click() Worksheets("All Tasks").Activate Call Update_All 'this calls the update_all macro that updates all the figures on all tasks worksheet Unload UserForm3 Worksheets("Information").Activate End Sub
Bookmarks