To show the userform with out saving changes in Excel

[jagadeesh]

Hi all,

I have a macro which is assigned to a button in Excel (custom toolbar).
By clicking that i get a form which is designed in VBA.
It is working fine, if i make any changes in excel and if i click that button
with out saving the changes , it is not showing me the form ,
If i save the changes and click on that it is showing the form.
I don't want to do like , whether it is saved or not, if click on the
button it has to show the form. What to do for that.
Do i have to change the code to save all the changes by programmatically and
call that form or any thing else more
Here another problem is that if i change data in cell and click on the any other cells
than it is working fine and if i stay in that cell the click on the button it is showing nothing
and in VBA editor it not working until i save the data or click on the any other cell.

Kindly help on this...

Thanks
This message was edited by jagadeesh on 2002-10-04 00:00

 

[Fryer Tuck]

When you edit data and then click on the button, are you still in the edit mode for the cell? (If you have not pressed "Enter", the button may not work.)

Other than that, look at the source code for the button. There may be something there disallowing the form to be shown.

F.T.