Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Formula Wizard - Can't pick cell from other sheet

0

Dear All,

i've a strange problem. With office 2007 when i'm using the formula wizard (when we click on Fx and we have a form with textbox for each parameter), if i click in any cell of the active sheet, the cell address appers on formula with no problem.

If i try to change the sheet to pick a cell on that sheet, windows do a error sound and i can't change to another sheet.

No error message box appears, just the sound.

I've 2 computers with same office, 1 one works on the another don't.

There is any parameters? or fix for this?

Thanks

Answer
Discuss

Discussion

Weird. Do you have any macros running in these workbooks? Also, what function are you trying to input?
don (rep: 1989) Aug 18, '16 at 1:05 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login