View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nader Nader is offline
external usenet poster
 
Posts: 44
Default problem to access sheet from add-in

Hello,

I've createad an add-in (with a function called ratings) in which I get some
value from a sheet that have to be created in order to use my add-in. It
worked perfectly for a few days but now whenever I open my excel sheet and
the use the function from my add-in I get an error because excel cannot find
the sheet I use to make some calculation in my excel file. I think that my
add-in is tryin to the sheet within my add-in ...

Please someone help me ! Thanks in advance.

I use the following code to make sure I can acces a specific sheet in my
add-in:

Dim wSheet As Worksheet

On Error Resume Next

Set wSheet = Sheets("ratings_sheet")

if wSheet is Nothing then
msgbox "i've got a serious problem"
else
msgbox "everything is cool"
end if