Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108749

Re: Suggestions please

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: Suggestions please
Date 2016-04-15 17:31 +0200
Organization A noiseless patient Spider
Message-ID <ner19r$9it$1@dont-email.me> (permalink)
References <fa00c318-6f91-4ae0-bb83-6586d086dd6c@googlegroups.com>

Show all headers | View raw

Hi Steve,

Am Fri, 15 Apr 2016 07:54:05 -0700 (PDT) schrieb pctamers@pctamers.eu:

> All I need addressing is the fact that it's not recognising the signature and so is looping.

is that Paint shape the only shape in the sheet? If so you can check in 
Button_Click event 

If Activesheet.Shapes.Count = 1 then
	exit sub
else
	call your macro
end if


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Suggestions please pctamers@pctamers.eu - 2016-04-15 07:54 -0700
  Re: Suggestions please Claus Busch <claus_busch@t-online.de> - 2016-04-15 17:31 +0200
    Re: Suggestions please Steve <pctamers@pctamers.eu> - 2016-04-18 05:14 -0700
      Re: Suggestions please Claus Busch <claus_busch@t-online.de> - 2016-04-18 14:29 +0200

csiph-web