Refresh spreadsheet via button

[puuts]

Hello,

I have a shared macro workbook and the inputs where come from a userform. I have a 'Add', 'Save', 'Refresh' buttons.
This workbook were also using by other users at the sametime.

My problem is, I would like to assign a macro in the 'Refresh' button that refreshes the spreadsheeet if the other user enters a new data.

I've used the below code in the 'Refresh' button but still not working.

Please Login or Register  to view this content.

Thanks in advance!

[swoop99]

try

Please Login or Register  to view this content.

instead

[puuts]

Hi Swoop,

Thanks for the reply, but either

Please Login or Register  to view this content.

is not working.

[Steve@Rugby]

Hi,

Why not just set updates to Automatic?

Regards
Steve